package com.tencent.mapper;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.sql.Date;

public interface ShowMember {

    /**
     * 会员总数
     */
    @Select("select count(*) from t_member ")
    int showAllMember();

    /**
     * 预约数量
     */
    @Select("select count(*) from t_order where orderDate>=#{time1} and orderDate<=#{time2}")
    int showOrderNum(@Param("time1")Date time1, @Param("time2")Date time2);
}
